Hierarchy Types
In Pyramid, there are several different types of hierarchy, depending on the datasource and/ or the way in which the hierarchies were constructed in Pyramid. Each hierarchy type is associate with specific features and functions.
Attribute Hierarchies
Attribute hierarchies are "flat" hierarchies existing in the original data source, and containing member elements; each attribute hierarchy corresponds to a single column imported from the data source. The member elements contained within the attribute hierarchy correspond to the objects within the column imported from the datasource.
Attribute hierarchies do not enable drill paths; to leverage drill functions, you must add a regular hierarchy or a drill path hierarchy.
Regular Hierarchies
Regular hierarchies contain multiple attribute hierarchies, organized into levels, thereby enabling drill functionality. They also display expand and collapse buttons in grid visualizations, and display the drill path in the Elements panel.
Drill Path Hierarchies
While drill path hierarchies are structurally the same as regular hierarchies, unlike regular hierarchies, they do not display expand and collapse icons in grid visualizations. Instead, the expand and collapse functions are accessed via the context menu, and the expanded levels are displays in a new column.
Drill path hierarchies also reflect the current hierarchy level in the drop zones and Elements panel, rather than displaying the drill path.
Geospatial Hierarchies
Geospatial Hierarchies are hierarchies containing geographical locations (like latitude, longitude, countries, states, cities, or zip codes) that have been assigned to a geospatial type. Geospatial hierarchies can be used to create map visualizations, in order to display your data set across a geographic location.
Date-Time Hierarchies
Date-Time Hierarchies are hierarchies containing date-time member elements and have been assigned as a date-time type. They can be added to the query, or used to create classic date-time groupings (like year, month, week, etc), or to construct complex date-time calculations that can be saved and added to the query. They can also be used to create calendar slicers, where you can filter the query by date-time groupings or formulations that don't exist in the date model.
Parent-Child Hierarchies
In MS OLAP, Tabular, and SAP models, the hierarchical structures configured in the cube are reflected in Pyramid. Parent-Child Hierarchies in MS OLAP and BW datasources are reflected in Pyramid; these hierarchies can be easily navigated, and can be used to create custom lists and formulas.
Image Hierarchies
Hierarchies consisting of image URLs can be added to the query, and the corresponding images displayed when the given visualization type is a grid or Cartesian chart. Click here to learn more.